package com.gaoxinfu.demo.spring.cloud.jpa.customize.dto.request;

import com.gaoxinfu.demo.spring.cloud.jpa.customize.annotation.JpaColumn;
import com.gaoxinfu.demo.spring.cloud.jpa.customize.annotation.JpaOperator;
import com.gaoxinfu.demo.spring.cloud.jpa.customize.constant.JpaOperatorConstant;
import lombok.AllArgsConstructor;
import lombok.Data;

/**
 * @Description:
 * @Author: gaoxinfu
 * @Date: 7/7/21 07:57
 */
@Data
@AllArgsConstructor
public class QueryEmpInfoByDeptNoReqDTO extends BaseReqDTO{

    /**
     * @see com.gaoxinfu.demo.spring.cloud.jpa.customize.entity.Dept#deptno
     */
    @JpaColumn(value = "wcd.whitecompany_name")
    @JpaOperator(value = JpaOperatorConstant.EQUALS)
    private Integer deptno;
    private StringBuilder sql = new StringBuilder("select ename,sal,dname,loc from emp inner join dept on empno=7788 and emp.deptno=dept.deptno;");
}
